create table sys_dept
(
    dept_id     int not null,
    parent_id   int         default 0,
    ancestors   varchar(50) default '',
    dept_name   varchar(30) default '',
    order_num   int         default 0,
    leader      varchar(20) default null,
    phone       varchar(11) default null,
    email       varchar(50) default null,
    status      char(1)     default '0',
    del_flag    char(1)     default '0',
    create_by   varchar(64) default '',
    create_time date,
    update_by   varchar(64) default '',
    update_time date,
    primary key (dept_id)
);
CREATE SEQUENCE sys_dept_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_dept_increase
    BEFORE
        insert
    ON sys_dept
    FOR EACH ROW
begin
    select sys_dept_Sequence.nextval into :New.dept_id from dual;
end;

-- ----------------------------
-- 初始化-部门表数据
-- ----------------------------
insert into SYS_DEPT
values (100, 0, '0', '测试科技', 0, '测试', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'));
insert into sys_dept
values (101, 100, '0,100', '深圳总公司', 1, '测试', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'));
insert into sys_dept
values (102, 100, '0,100', '长沙分公司', 2, '测试', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'));
insert into sys_dept
values (103, 101, '0,100,101', '研发部门', 1, '测试', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'));
insert into sys_dept
values (104, 101, '0,100,101', '市场部门', 2, '测试', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'));
insert into sys_dept
values (105, 101, '0,100,101', '测试部门', 3, '测试', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'));
insert into sys_dept
values (106, 101, '0,100,101', '财务部门', 4, '测试', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'));
insert into sys_dept
values (107, 101, '0,100,101', '运维部门', 5, '测试', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'));
insert into sys_dept
values (108, 102, '0,100,102', '市场部门', 1, '测试', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'));
insert into sys_dept
values (109, 102, '0,100,102', '财务部门', 2, '测试', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'));

select *
from SYS_DEPT;


-- ----------------------------
-- 2、用户信息表
-- ----------------------------
create table sys_user
(
    user_id     int         not null,
    dept_id     int          default null,
    login_name  varchar(30) not null,
    user_name   varchar(30) not null,
    user_type   varchar(2)   default '00',
    email       varchar(50)  default '',
    phonenumber varchar(11)  default '',
    sex         char(1)      default '0',
    avatar      varchar(100) default '',
    password    varchar(50)  default '',
    salt        varchar(20)  default '',
    status      char(1)      default '0',
    del_flag    char(1)      default '0',
    login_ip    varchar(50)  default '',
    login_date  date,
    create_by   varchar(64)  default '',
    create_time date,
    update_by   varchar(64)  default '',
    update_time date,
    remark      varchar(500) default null,
    primary key (user_id)
);
CREATE SEQUENCE sys_user_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_user_increase
    BEFORE
        insert
    ON sys_user
    FOR EACH ROW
begin
    select sys_user_Sequence.nextval into :New.user_id from dual;
end;

-- ----------------------------
-- 初始化-用户信息表数据
-- ----------------------------
insert into sys_user
values (1, 103, 'admin', '测试', '00', 'ry@163.com', '15888888888', '1', '', '29c67a30398638269fe600f73a054934', '111111',
        '0', '0', '127.0.0.1', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '管理员');
insert into sys_user
values (2, 105, 'ry', '测试', '00', 'ry@qq.com', '15666666666', '1', '', '8e6d98b90472783cc73c17047ddccf36', '222222',
        '0', '0', '127.0.0.1', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '测试员');

select *
from SYS_USER;

-- ----------------------------
-- 3、岗位信息表
-- ----------------------------
create table sys_post
(
    post_id     int         not null,
    post_code   varchar(64) not null,
    post_name   varchar(50) not null,
    post_sort   int         not null,
    status      char(1)     not null,
    create_by   varchar(64)  default '',
    create_time date,
    update_by   varchar(64)  default '',
    update_time date,
    remark      varchar(500) default null,
    primary key (post_id)
);
CREATE SEQUENCE sys_post_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_post_increase
    BEFORE
        insert
    ON sys_post
    FOR EACH ROW
begin
    select sys_post_Sequence.nextval into :New.post_id from dual;
end;


-- ----------------------------
-- 初始化-岗位信息表数据
-- ----------------------------
insert into sys_post
values (1, 'ceo', '董事长', 1, '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_post
values (2, 'se', '项目经理', 2, '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_post
values (3, 'hr', '人力资源', 3, '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_post
values (4, 'user', '普通员工', 4, '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');


-- ----------------------------
-- 4、角色信息表
-- ----------------------------
create table sys_role
(
    role_id     int          not null,
    role_name   varchar(30)  not null,
    role_key    varchar(100) not null,
    role_sort   int          not null,
    data_scope  char(1)      default '1',
    status      char(1)      not null,
    del_flag    char(1)      default '0',
    create_by   varchar(64)  default '',
    create_time date,
    update_by   varchar(64)  default '',
    update_time date,
    remark      varchar(500) default null,
    primary key (role_id)
);
CREATE SEQUENCE sys_role_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_role_increase
    BEFORE
        insert
    ON sys_role
    FOR EACH ROW
begin
    select sys_role_Sequence.nextval into :New.role_id from dual;
end;

-- ----------------------------
-- 初始化-角色信息表数据
-- ----------------------------
insert into sys_role
values ('1', '管理员', 'admin', 1, 1, '0', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '管理员');
insert into sys_role
values ('2', '普通角色', 'common', 2, 2, '0', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '普通角色');


-- ----------------------------
-- 5、菜单权限表
-- ----------------------------
create table sys_menu
(
    menu_id     int         not null,
    menu_name   varchar(50) not null,
    parent_id   int          default 0,
    order_num   int          default 0,
    url         varchar(200) default '#',
    target      varchar(20)  default '',
    menu_type   char(1)      default '',
    visible     char(1)      default 0,
    perms       varchar(100) default null,
    icon        varchar(100) default '#',
    create_by   varchar(64)  default '',
    create_time date,
    update_by   varchar(64)  default '',
    update_time date,
    remark      varchar(500) default '',
    primary key (menu_id)
);
CREATE SEQUENCE sys_menu_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_menu_increase
    BEFORE
        insert
    ON sys_menu
    FOR EACH ROW
begin
    select sys_menu_Sequence.nextval into :New.menu_id from dual;
end;

-- ----------------------------
-- 初始化-菜单信息表数据
-- ----------------------------
-- 一级菜单
insert into sys_menu
values ('1', '系统管理', '0', '1', '#', '', 'M', '0', '', 'fa fa-gear', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '系统管理目录');
insert into sys_menu
values ('2', '系统监控', '0', '2', '#', '', 'M', '0', '', 'fa fa-video-camera', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '系统监控目录');
insert into sys_menu
values ('3', '系统工具', '0', '3', '#', '', 'M', '0', '', 'fa fa-bars', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '系统工具目录');
-- 二级菜单
insert into sys_menu
values ('100', '用户管理', '1', '1', '/system/user', '', 'C', '0', 'system:user:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '用户管理菜单');
insert into sys_menu
values ('101', '角色管理', '1', '2', '/system/role', '', 'C', '0', 'system:role:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '角色管理菜单');
insert into sys_menu
values ('102', '菜单管理', '1', '3', '/system/menu', '', 'C', '0', 'system:menu:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '菜单管理菜单');
insert into sys_menu
values ('103', '部门管理', '1', '4', '/system/dept', '', 'C', '0', 'system:dept:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '部门管理菜单');
insert into sys_menu
values ('104', '岗位管理', '1', '5', '/system/post', '', 'C', '0', 'system:post:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '岗位管理菜单');
insert into sys_menu
values ('105', '字典管理', '1', '6', '/system/dict', '', 'C', '0', 'system:dict:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '字典管理菜单');
insert into sys_menu
values ('106', '参数设置', '1', '7', '/system/config', '', 'C', '0', 'system:config:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '参数设置菜单');
insert into sys_menu
values ('107', '通知公告', '1', '8', '/system/notice', '', 'C', '0', 'system:notice:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '通知公告菜单');
insert into sys_menu
values ('108', '日志管理', '1', '9', '#', '', 'M', '0', '', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '日志管理菜单');
insert into sys_menu
values ('109', '在线用户', '2', '1', '/monitor/online', '', 'C', '0', 'monitor:online:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '在线用户菜单');
insert into sys_menu
values ('110', '定时任务', '2', '2', '/monitor/job', '', 'C', '0', 'monitor:job:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '定时任务菜单');
insert into sys_menu
values ('111', '数据监控', '2', '3', '/monitor/data', '', 'C', '0', 'monitor:data:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '数据监控菜单');
insert into sys_menu
values ('112', '服务监控', '2', '3', '/monitor/server', '', 'C', '0', 'monitor:server:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '服务监控菜单');
insert into sys_menu
values ('113', '表单构建', '3', '1', '/tool/build', '', 'C', '0', 'tool:build:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '表单构建菜单');
insert into sys_menu
values ('114', '代码生成', '3', '2', '/tool/gen', '', 'C', '0', 'tool:gen:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '代码生成菜单');
insert into sys_menu
values ('115', '系统接口', '3', '3', '/tool/swagger', '', 'C', '0', 'tool:swagger:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '系统接口菜单');
-- 三级菜单
insert into sys_menu
values ('500', '操作日志', '108', '1', '/monitor/operlog', '', 'C', '0', 'monitor:operlog:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '操作日志菜单');
insert into sys_menu
values ('501', '登录日志', '108', '2', '/monitor/logininfor', '', 'C', '0', 'monitor:logininfor:view', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '登录日志菜单');
-- 用户管理按钮
insert into sys_menu
values ('1000', '用户查询', '100', '1', '#', '', 'F', '0', 'system:user:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1001', '用户新增', '100', '2', '#', '', 'F', '0', 'system:user:add', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1002', '用户修改', '100', '3', '#', '', 'F', '0', 'system:user:edit', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1003', '用户删除', '100', '4', '#', '', 'F', '0', 'system:user:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1004', '用户导出', '100', '5', '#', '', 'F', '0', 'system:user:export', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1005', '用户导入', '100', '6', '#', '', 'F', '0', 'system:user:import', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1006', '重置密码', '100', '7', '#', '', 'F', '0', 'system:user:resetPwd', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 角色管理按钮
insert into sys_menu
values ('1007', '角色查询', '101', '1', '#', '', 'F', '0', 'system:role:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1008', '角色新增', '101', '2', '#', '', 'F', '0', 'system:role:add', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1009', '角色修改', '101', '3', '#', '', 'F', '0', 'system:role:edit', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1010', '角色删除', '101', '4', '#', '', 'F', '0', 'system:role:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1011', '角色导出', '101', '5', '#', '', 'F', '0', 'system:role:export', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 菜单管理按钮
insert into sys_menu
values ('1012', '菜单查询', '102', '1', '#', '', 'F', '0', 'system:menu:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1013', '菜单新增', '102', '2', '#', '', 'F', '0', 'system:menu:add', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1014', '菜单修改', '102', '3', '#', '', 'F', '0', 'system:menu:edit', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1015', '菜单删除', '102', '4', '#', '', 'F', '0', 'system:menu:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 部门管理按钮
insert into sys_menu
values ('1016', '部门查询', '103', '1', '#', '', 'F', '0', 'system:dept:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1017', '部门新增', '103', '2', '#', '', 'F', '0', 'system:dept:add', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1018', '部门修改', '103', '3', '#', '', 'F', '0', 'system:dept:edit', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1019', '部门删除', '103', '4', '#', '', 'F', '0', 'system:dept:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 岗位管理按钮
insert into sys_menu
values ('1020', '岗位查询', '104', '1', '#', '', 'F', '0', 'system:post:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1021', '岗位新增', '104', '2', '#', '', 'F', '0', 'system:post:add', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1022', '岗位修改', '104', '3', '#', '', 'F', '0', 'system:post:edit', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1023', '岗位删除', '104', '4', '#', '', 'F', '0', 'system:post:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1024', '岗位导出', '104', '5', '#', '', 'F', '0', 'system:post:export', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 字典管理按钮
insert into sys_menu
values ('1025', '字典查询', '105', '1', '#', '', 'F', '0', 'system:dict:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1026', '字典新增', '105', '2', '#', '', 'F', '0', 'system:dict:add', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1027', '字典修改', '105', '3', '#', '', 'F', '0', 'system:dict:edit', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1028', '字典删除', '105', '4', '#', '', 'F', '0', 'system:dict:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1029', '字典导出', '105', '5', '#', '', 'F', '0', 'system:dict:export', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 参数设置按钮
insert into sys_menu
values ('1030', '参数查询', '106', '1', '#', '', 'F', '0', 'system:config:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1031', '参数新增', '106', '2', '#', '', 'F', '0', 'system:config:add', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1032', '参数修改', '106', '3', '#', '', 'F', '0', 'system:config:edit', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1033', '参数删除', '106', '4', '#', '', 'F', '0', 'system:config:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1034', '参数导出', '106', '5', '#', '', 'F', '0', 'system:config:export', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 通知公告按钮
insert into sys_menu
values ('1035', '公告查询', '107', '1', '#', '', 'F', '0', 'system:notice:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1036', '公告新增', '107', '2', '#', '', 'F', '0', 'system:notice:add', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1037', '公告修改', '107', '3', '#', '', 'F', '0', 'system:notice:edit', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1038', '公告删除', '107', '4', '#', '', 'F', '0', 'system:notice:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 操作日志按钮
insert into sys_menu
values ('1039', '操作查询', '500', '1', '#', '', 'F', '0', 'monitor:operlog:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1040', '操作删除', '500', '2', '#', '', 'F', '0', 'monitor:operlog:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1041', '详细信息', '500', '3', '#', '', 'F', '0', 'monitor:operlog:detail', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1042', '日志导出', '500', '4', '#', '', 'F', '0', 'monitor:operlog:export', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 登录日志按钮
insert into sys_menu
values ('1043', '登录查询', '501', '1', '#', '', 'F', '0', 'monitor:logininfor:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1044', '登录删除', '501', '2', '#', '', 'F', '0', 'monitor:logininfor:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1045', '日志导出', '501', '3', '#', '', 'F', '0', 'monitor:logininfor:export', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1046', '账户解锁', '501', '4', '#', '', 'F', '0', 'monitor:logininfor:unlock', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 在线用户按钮
insert into sys_menu
values ('1047', '在线查询', '109', '1', '#', '', 'F', '0', 'monitor:online:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1048', '批量强退', '109', '2', '#', '', 'F', '0', 'monitor:online:batchForceLogout', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1049', '单条强退', '109', '3', '#', '', 'F', '0', 'monitor:online:forceLogout', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 定时任务按钮
insert into sys_menu
values ('1050', '任务查询', '110', '1', '#', '', 'F', '0', 'monitor:job:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1051', '任务新增', '110', '2', '#', '', 'F', '0', 'monitor:job:add', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1052', '任务修改', '110', '3', '#', '', 'F', '0', 'monitor:job:edit', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1053', '任务删除', '110', '4', '#', '', 'F', '0', 'monitor:job:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1054', '状态修改', '110', '5', '#', '', 'F', '0', 'monitor:job:changeStatus', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1055', '任务详细', '110', '6', '#', '', 'F', '0', 'monitor:job:detail', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1056', '任务导出', '110', '7', '#', '', 'F', '0', 'monitor:job:export', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
-- 代码生成按钮
insert into sys_menu
values ('1057', '生成查询', '114', '1', '#', '', 'F', '0', 'tool:gen:list', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1058', '生成修改', '114', '2', '#', '', 'F', '0', 'tool:gen:edit', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1059', '生成删除', '114', '3', '#', '', 'F', '0', 'tool:gen:remove', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1060', '预览代码', '114', '4', '#', '', 'F', '0', 'tool:gen:preview', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_menu
values ('1061', '生成代码', '114', '5', '#', '', 'F', '0', 'tool:gen:code', '#', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');


-- ----------------------------
-- 6、用户和角色关联表  用户N-1角色
-- ----------------------------
create table sys_user_role
(
    user_id int not null,
    role_id int not null,
    primary key (user_id, role_id)
);

-- ----------------------------
-- 初始化-用户和角色关联表数据
-- ----------------------------
insert into sys_user_role
values ('1', '1');
insert into sys_user_role
values ('2', '2');


-- ----------------------------
-- 7、角色和菜单关联表  角色1-N菜单
-- ----------------------------
create table sys_role_menu
(
    role_id int not null,
    menu_id int not null,
    primary key (role_id, menu_id)
);

-- ----------------------------
-- 初始化-角色和菜单关联表数据
-- ----------------------------
insert into sys_role_menu
values ('2', '1');
insert into sys_role_menu
values ('2', '2');
insert into sys_role_menu
values ('2', '3');
insert into sys_role_menu
values ('2', '100');
insert into sys_role_menu
values ('2', '101');
insert into sys_role_menu
values ('2', '102');
insert into sys_role_menu
values ('2', '103');
insert into sys_role_menu
values ('2', '104');
insert into sys_role_menu
values ('2', '105');
insert into sys_role_menu
values ('2', '106');
insert into sys_role_menu
values ('2', '107');
insert into sys_role_menu
values ('2', '108');
insert into sys_role_menu
values ('2', '109');
insert into sys_role_menu
values ('2', '110');
insert into sys_role_menu
values ('2', '111');
insert into sys_role_menu
values ('2', '112');
insert into sys_role_menu
values ('2', '113');
insert into sys_role_menu
values ('2', '114');
insert into sys_role_menu
values ('2', '115');
insert into sys_role_menu
values ('2', '500');
insert into sys_role_menu
values ('2', '501');
insert into sys_role_menu
values ('2', '1000');
insert into sys_role_menu
values ('2', '1001');
insert into sys_role_menu
values ('2', '1002');
insert into sys_role_menu
values ('2', '1003');
insert into sys_role_menu
values ('2', '1004');
insert into sys_role_menu
values ('2', '1005');
insert into sys_role_menu
values ('2', '1006');
insert into sys_role_menu
values ('2', '1007');
insert into sys_role_menu
values ('2', '1008');
insert into sys_role_menu
values ('2', '1009');
insert into sys_role_menu
values ('2', '1010');
insert into sys_role_menu
values ('2', '1011');
insert into sys_role_menu
values ('2', '1012');
insert into sys_role_menu
values ('2', '1013');
insert into sys_role_menu
values ('2', '1014');
insert into sys_role_menu
values ('2', '1015');
insert into sys_role_menu
values ('2', '1016');
insert into sys_role_menu
values ('2', '1017');
insert into sys_role_menu
values ('2', '1018');
insert into sys_role_menu
values ('2', '1019');
insert into sys_role_menu
values ('2', '1020');
insert into sys_role_menu
values ('2', '1021');
insert into sys_role_menu
values ('2', '1022');
insert into sys_role_menu
values ('2', '1023');
insert into sys_role_menu
values ('2', '1024');
insert into sys_role_menu
values ('2', '1025');
insert into sys_role_menu
values ('2', '1026');
insert into sys_role_menu
values ('2', '1027');
insert into sys_role_menu
values ('2', '1028');
insert into sys_role_menu
values ('2', '1029');
insert into sys_role_menu
values ('2', '1030');
insert into sys_role_menu
values ('2', '1031');
insert into sys_role_menu
values ('2', '1032');
insert into sys_role_menu
values ('2', '1033');
insert into sys_role_menu
values ('2', '1034');
insert into sys_role_menu
values ('2', '1035');
insert into sys_role_menu
values ('2', '1036');
insert into sys_role_menu
values ('2', '1037');
insert into sys_role_menu
values ('2', '1038');
insert into sys_role_menu
values ('2', '1039');
insert into sys_role_menu
values ('2', '1040');
insert into sys_role_menu
values ('2', '1041');
insert into sys_role_menu
values ('2', '1042');
insert into sys_role_menu
values ('2', '1043');
insert into sys_role_menu
values ('2', '1044');
insert into sys_role_menu
values ('2', '1045');
insert into sys_role_menu
values ('2', '1046');
insert into sys_role_menu
values ('2', '1047');
insert into sys_role_menu
values ('2', '1048');
insert into sys_role_menu
values ('2', '1049');
insert into sys_role_menu
values ('2', '1050');
insert into sys_role_menu
values ('2', '1051');
insert into sys_role_menu
values ('2', '1052');
insert into sys_role_menu
values ('2', '1053');
insert into sys_role_menu
values ('2', '1054');
insert into sys_role_menu
values ('2', '1055');
insert into sys_role_menu
values ('2', '1056');
insert into sys_role_menu
values ('2', '1057');
insert into sys_role_menu
values ('2', '1058');
insert into sys_role_menu
values ('2', '1059');
insert into sys_role_menu
values ('2', '1060');
insert into sys_role_menu
values ('2', '1061');

-- ----------------------------
-- 8、角色和部门关联表  角色1-N部门
-- ----------------------------
create table sys_role_dept
(
    role_id int not null,
    dept_id int not null,
    primary key (role_id, dept_id)
);

-- ----------------------------
-- 初始化-角色和部门关联表数据
-- ----------------------------
insert into sys_role_dept
values ('2', '100');
insert into sys_role_dept
values ('2', '101');
insert into sys_role_dept
values ('2', '105');

-- ----------------------------
-- 9、用户与岗位关联表  用户1-N岗位
-- ----------------------------
create table sys_user_post
(
    user_id int not null,
    post_id int not null,
    primary key (user_id, post_id)
);

-- ----------------------------
-- 初始化-用户与岗位关联表数据
-- ----------------------------
insert into sys_user_post
values ('1', '1');
insert into sys_user_post
values ('2', '2');


-- ----------------------------
-- 10、操作日志记录
-- ----------------------------
create table sys_oper_log
(
    oper_id        int not null,
    title          varchar(50)   default '',
    business_type  int           default 0,
    method         varchar(100)  default '',
    request_method varchar(10)   default '',
    operator_type  int           default 0,
    oper_name      varchar(50)   default '',
    dept_name      varchar(50)   default '',
    oper_url       varchar(255)  default '',
    oper_ip        varchar(50)   default '',
    oper_location  varchar(255)  default '',
    oper_param     varchar(2000) default '',
    json_result    varchar(2000) default '',
    status         int           default 0,
    error_msg      varchar(2000) default '',
    oper_time      date,
    primary key (oper_id)
);
CREATE SEQUENCE sys_oper_log_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_oper_log_increase
    BEFORE
        insert
    ON sys_oper_log
    FOR EACH ROW
begin
    select sys_oper_log_Sequence.nextval into :New.oper_id from dual;
end;


-- ----------------------------
-- 11、字典类型表
-- ----------------------------
create table sys_dict_type
(
    dict_id     int not null,
    dict_name   varchar(100) default '',
    dict_type   varchar(100) default '',
    status      char(1)      default '0',
    create_by   varchar(64)  default '',
    create_time date,
    update_by   varchar(64)  default '',
    update_time date,
    remark      varchar(500) default null,
    primary key (dict_id),
    unique (dict_type)
);
CREATE SEQUENCE sys_dict_type_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_dict_type_increase
    BEFORE
        insert
    ON sys_dict_type
    FOR EACH ROW
begin
    select sys_dict_type_Sequence.nextval into :New.dict_id from dual;
end;

insert into sys_dict_type
values (1, '用户性别', 'sys_user_sex', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '用户性别列表');
insert into sys_dict_type
values (2, '菜单状态', 'sys_show_hide', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '菜单状态列表');
insert into sys_dict_type
values (3, '系统开关', 'sys_normal_disable', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '系统开关列表');
insert into sys_dict_type
values (4, '任务状态', 'sys_job_status', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '任务状态列表');
insert into sys_dict_type
values (5, '任务分组', 'sys_job_group', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '任务分组列表');
insert into sys_dict_type
values (6, '系统是否', 'sys_yes_no', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '系统是否列表');
insert into sys_dict_type
values (7, '通知类型', 'sys_notice_type', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '通知类型列表');
insert into sys_dict_type
values (8, '通知状态', 'sys_notice_status', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '通知状态列表');
insert into sys_dict_type
values (9, '操作类型', 'sys_oper_type', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '操作类型列表');
insert into sys_dict_type
values (10, '系统状态', 'sys_common_status', '0', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '登录状态列表');


-- ----------------------------
-- 12、字典数据表
-- ----------------------------
create table sys_dict_data
(
    dict_code   int not null,
    dict_sort   int          default 0,
    dict_label  varchar(100) default '',
    dict_value  varchar(100) default '',
    dict_type   varchar(100) default '',
    css_class   varchar(100) default null,
    list_class  varchar(100) default null,
    is_default  char(1)      default 'N',
    status      char(1)      default '0',
    create_by   varchar(64)  default '',
    create_time date,
    update_by   varchar(64)  default '',
    update_time date,
    remark      varchar(500) default null,
    primary key (dict_code)
);
CREATE SEQUENCE sys_dict_data_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_dict_data_increase
    BEFORE
        insert
    ON sys_dict_data
    FOR EACH ROW
begin
    select sys_dict_data_Sequence.nextval into :New.dict_code from dual;
end;

insert into sys_dict_data
values (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '性别男');
insert into sys_dict_data
values (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '性别女');
insert into sys_dict_data
values (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '性别未知');
insert into sys_dict_data
values (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '显示菜单');
insert into sys_dict_data
values (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '隐藏菜单');
insert into sys_dict_data
values (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '正常状态');
insert into sys_dict_data
values (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '停用状态');
insert into sys_dict_data
values (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '正常状态');
insert into sys_dict_data
values (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '停用状态');
insert into sys_dict_data
values (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '默认分组');
insert into sys_dict_data
values (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '系统分组');
insert into sys_dict_data
values (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '系统默认是');
insert into sys_dict_data
values (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '系统默认否');
insert into sys_dict_data
values (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '通知');
insert into sys_dict_data
values (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '公告');
insert into sys_dict_data
values (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '正常状态');
insert into sys_dict_data
values (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '关闭状态');
insert into sys_dict_data
values (18, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '新增操作');
insert into sys_dict_data
values (19, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '修改操作');
insert into sys_dict_data
values (20, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '删除操作');
insert into sys_dict_data
values (21, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '授权操作');
insert into sys_dict_data
values (22, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '导出操作');
insert into sys_dict_data
values (23, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '导入操作');
insert into sys_dict_data
values (24, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '强退操作');
insert into sys_dict_data
values (25, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '生成操作');
insert into sys_dict_data
values (26, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '清空操作');
insert into sys_dict_data
values (27, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '正常状态');
insert into sys_dict_data
values (28, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '停用状态');


-- ----------------------------
-- 13、参数配置表
-- ----------------------------
create table sys_config
(
    config_id    int not null,
    config_name  varchar(100) default '',
    config_key   varchar(100) default '',
    config_value varchar(500) default '',
    config_type  char(1)      default 'N',
    create_by    varchar(64)  default '',
    create_time  date,
    update_by    varchar(64)  default '',
    update_time  date,
    remark       varchar(500) default null,
    primary key (config_id)
);
CREATE SEQUENCE sys_config_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_config_increase
    BEFORE
        insert
    ON sys_config
    FOR EACH ROW
begin
    select sys_config_Sequence.nextval into :New.config_id from dual;
end;

insert into sys_config
values (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'),
        '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
insert into sys_config
values (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '初始化密码 123456');
insert into sys_config
values (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '深黑主题theme-dark，浅色主题theme-light，深蓝主题theme-blue');


-- ----------------------------
-- 14、系统访问记录
-- ----------------------------
create table sys_logininfor
(
    info_id        int not null,
    login_name     varchar(50)  default '',
    ipaddr         varchar(50)  default '',
    login_location varchar(255) default '',
    browser        varchar(50)  default '',
    os             varchar(50)  default '',
    status         char(1)      default '0',
    msg            varchar(255) default '',
    login_time     date,
    primary key (info_id)
);
CREATE SEQUENCE sys_logininfor_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_logininfor_increase
    BEFORE
        insert
    ON sys_logininfor
    FOR EACH ROW
begin
    select sys_logininfor_Sequence.nextval into :New.info_id from dual;
end;


-- ----------------------------
-- 15、在线用户记录
-- ----------------------------
create table sys_user_online
(
    sessionId        varchar(50)  default '',
    login_name       varchar(50)  default '',
    dept_name        varchar(50)  default '',
    ipaddr           varchar(50)  default '',
    login_location   varchar(255) default '',
    browser          varchar(50)  default '',
    os               varchar(50)  default '',
    status           varchar(10)  default '',
    start_timestamp  date,
    last_access_time date,
    expire_time      int          default 0,
    primary key (sessionId)
);



-- ----------------------------
-- 16、定时任务调度表
-- ----------------------------
create table sys_job
(
    job_id          int      not null,
    job_name        varchar(64)  default '',
    job_group       varchar(64)  default 'DEFAULT',
    invoke_target   varchar(500) not null,
    cron_expression varchar(255) default '',
    misfire_policy  varchar(20)  default '3',
    concurrent      char(1)      default '1',
    status          char(1)      default '0',
    create_by       varchar(64)  default '',
    create_time     date,
    update_by       varchar(64)  default '',
    update_time     date,
    remark          varchar(500) default '',
    primary key (job_id, job_name, job_group)
);
CREATE SEQUENCE sys_job_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_job_increase
    BEFORE
        insert
    ON sys_job
    FOR EACH ROW
begin
    select sys_job_Sequence.nextval into :New.job_id from dual;
end;

insert into sys_job
values (1, '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
--TODO 未插入
insert into sys_job
values (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');
insert into sys_job
values (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3',
        '1', '1', 'admin', to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '');


-- ----------------------------
-- 17、定时任务调度日志表
-- ----------------------------
create table sys_job_log
(
    job_log_id     int          not null,
    job_name       varchar(64)  not null,
    job_group      varchar(64)  not null,
    invoke_target  varchar(500) not null,
    job_message    varchar(500),
    status         char(1)       default '0',
    exception_info varchar(2000) default '',
    create_time    date,
    primary key (job_log_id)
);
CREATE SEQUENCE sys_job_log_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_job_log_increase
    BEFORE
        insert
    ON sys_job_log
    FOR EACH ROW
begin
    select sys_job_log_Sequence.nextval into :New.job_log_id from dual;
end;


-- ----------------------------
-- 18、通知公告表
-- ----------------------------
create table sys_notice
(
    notice_id      int      not null ,
    notice_title   varchar(50) not null,
    notice_type    char(1)     not null ,
    notice_content varchar(2000) default null ,
    status         char(1)       default '0',
    create_by      varchar(64)   default '' ,
    create_time    date ,
    update_by      varchar(64)   default '',
    update_time    date ,
    remark         varchar(255)  default null ,
    primary key (notice_id)
);

CREATE SEQUENCE sys_notice_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER sys_notice_increase
    BEFORE
        insert
    ON sys_notice
    FOR EACH ROW
begin
    select sys_notice_Sequence.nextval into :New.notice_id from dual;
end;

-- ----------------------------
-- 初始化-公告信息表数据
-- ----------------------------
insert into sys_notice
values ('1', '温馨提醒：2018-07-01 测试新版本发布啦', '2', '新版本内容', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '管理员');
insert into sys_notice
values ('2', '维护通知：2018-07-01 测试系统凌晨维护', '1', '维护内容', '0', 'admin',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), 'ry',
        to_date('2019-2-26 11:14:25', 'yyyy-mm-dd hh24:mi:ss'), '管理员');


-- ----------------------------
-- 19、代码生成业务表
-- ----------------------------
create table gen_table
(
    table_id        int not null ,
    table_name      varchar(200) default '' ,
    table_comment   varchar(500) default '' ,
    class_name      varchar(100) default '',
    tpl_category    varchar(200) default 'crud' ,
    package_name    varchar(100) ,
    module_name     varchar(30),
    business_name   varchar(30) ,
    function_name   varchar(50) ,
    function_author varchar(50) ,
    options         varchar(1000) ,
    create_by       varchar(64)  default '' ,
    create_time     date ,
    update_by       varchar(64)  default '' ,
    update_time     date ,
    remark          varchar(500) default null ,
    primary key (table_id)
);
CREATE SEQUENCE gen_table_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER gen_table_increase
    BEFORE
        insert
    ON gen_table
    FOR EACH ROW
begin
    select gen_table_Sequence.nextval into :New.table_id from dual;
end;


-- ----------------------------
-- 20、代码生成业务表字段
-- ----------------------------
create table gen_table_column
(
    column_id      int not null ,
    table_id       varchar(64) ,
    column_name    varchar(200) ,
    column_comment varchar(500) ,
    column_type    varchar(100) ,
    java_type      varchar(500) ,
    java_field     varchar(200) ,
    is_pk          char(1),
    is_increment   char(1) ,
    is_required    char(1),
    is_insert      char(1) ,
    is_edit        char(1) ,
    is_list        char(1) ,
    is_query       char(1) ,
    query_type     varchar(200) default 'EQ' ,
    html_type      varchar(200),
    dict_type      varchar(200) default '' ,
    sort           int ,
    create_by      varchar(64)  default '',
    create_time    date ,
    update_by      varchar(64)  default '',
    update_time    date ,
    primary key (column_id)
) ;
CREATE SEQUENCE gen_table_column_Sequence
    INCREMENT BY 1 -- 每次加几个
    START WITH 1 -- 从1开始计数
    NOMAXVALUE -- 不设置最大值
    NOCYCLE; -- 一直累加，不循环

CREATE TRIGGER gen_table_column_increase
    BEFORE
        insert
    ON gen_table_column
    FOR EACH ROW
begin
    select gen_table_column_Sequence.nextval into :New.column_id from dual;
end;